Tabela AuditTrial

Definicja tabeli AuditTrial

Name

AuditTrial

Code

AuditTrial

Comment

 


Lista kolumn tabeli AuditTrial

Name

Code

ID

ID

StuInsUID

StuInsUID

GRPatID

GRPatID

GRPatName

GRPatName

NRExamID

NRExamID

NRPatID

NRPatID

NRPatname

NRPatname

UpdUserID

UpdUserID

UpdDate

UpdDate

GRExamID

GRExamID

CNUserName

CNUserName

CNUserID

CNUserID


Kolumna ID tabeli AuditTrial

Definicja kolumny ID tabeli AuditTrial

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StuInsUID tabeli AuditTrial

Definicja kolumny StuInsUID tabeli AuditTrial

Name

StuInsUID

Code

StuInsUID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna GRPatID tabeli AuditTrial

Definicja kolumny GRPatID tabeli AuditTrial

Name

GRPatID

Code

GRPatID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna GRPatName tabeli AuditTrial

Definicja kolumny GRPatName tabeli AuditTrial

Name

GRPatName

Code

GRPatName

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna NRExamID tabeli AuditTrial

Definicja kolumny NRExamID tabeli AuditTrial

Name

NRExamID

Code

NRExamID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna NRPatID tabeli AuditTrial

Definicja kolumny NRPatID tabeli AuditTrial

Name

NRPatID

Code

NRPatID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna NRPatname tabeli AuditTrial

Definicja kolumny NRPatname tabeli AuditTrial

Name

NRPatname

Code

NRPatname

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli AuditTrial

Definicja kolumny UpdUserID tabeli AuditTrial

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli AuditTrial

Definicja kolumny UpdDate tabeli AuditTrial

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna GRExamID tabeli AuditTrial

Definicja kolumny GRExamID tabeli AuditTrial

Name

GRExamID

Code

GRExamID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna CNUserName tabeli AuditTrial

Definicja kolumny CNUserName tabeli AuditTrial

Name

CNUserName

Code

CNUserName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna CNUserID tabeli AuditTrial

Definicja kolumny CNUserID tabeli AuditTrial

Name

CNUserID

Code

CNUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli AuditTrial

Name

Code

Primary

AuditTrial_5370499181

AuditTrial_5370499181

X


Klucz AuditTrial_5370499181 tabeli AuditTrial

Definicja klucza AuditTrial_5370499181 tabeli AuditTrial

Name

AuditTrial_5370499181

Code

AuditTrial_5370499181

Primary

Yes

Comment